Go to the documentation of this file.
00001 
00027 using System;
00028 using System.Collections.Generic;
00029 using System.Text;
00030 
00031 namespace RAIS.DataAccessLayer
00032 {
00036     class Constants
00037         {
00038         //*********************************************************************
00039         #region Common
00040 
00043                 public const string RAIS_CONNECTION_STRING_NAME = "RAISConnectionString";
00044                 #endregion
00045         //*********************************************************************
00046                 #region Stored Procedures Names
00047 
00050                 public const string SP_NAME_AddUser = "usp_AddUser";
00054                 public const string SP_NAME_AddAccountRequest = "usp_AddAccountRequest";
00058                 public const string SP_NAME_ReleaseAccountRequest = "usp_ReleaseAccountRequest";
00062                 public const string SP_NAME_RejectAccountRequest = "usp_RejectAccountRequest";
00066                 public const string SP_NAME_UpdateUser = "usp_UpdateUser";
00070                 public const string SP_NAME_LoginUser = "usp_LoginUser";
00074                 public const string SP_NAME_LogoutUser = "usp_LogoutUser";
00078                 public const string SP_NAME_GetUsers = "usp_GetUsers";
00082                 public const string SP_NAME_GetValidators = "usp_GetValidators";
00086                 public const string SP_NAME_GetUserByUserName = "usp_GetUserByUserName";
00090                 public const string SP_NAME_GetUserTypes = "usp_GetUserTypes";
00094                 public const string SP_NAME_GetUserStatuses = "usp_GetUserStatuses";
00098                 public const string SP_NAME_AddDataRole = "usp_AddDataRole";
00102                 public const string SP_NAME_DeleteDataRole = "usp_DeleteDataRole";
00106                 public const string SP_NAME_GetDataRoles = "usp_GetDataRoles";
00110                 public const string SP_NAME_GetDataRoleAttributesByDataRoleID = "usp_GetDataRoleRestrictionsByDataRoleID";
00114                 public const string SP_NAME_AddFunctionalRole = "usp_AddFunctionalRole";
00118                 public const string SP_NAME_DeleteFunctionalRole = "usp_DeleteFunctionalRole";
00122                 public const string SP_NAME_GetFunctionalRoles = "usp_GetFunctionalRoles"; //#-#
00126         public const string SP_NAME_GetPractices = "usp_GetPractices";
00130                 public const string SP_NAME_GetFacilities = "usp_GetFacilities";
00134                 public const string SP_NAME_GetRegions = "usp_GetRegions";
00138                 public const string SP_NAME_GetCategories = "usp_GetCategories";
00142                 public const string SP_NAME_GetAllowCustomizationCategories = "usp_GetAllowCustomizationCategories";
00146                 public const string SP_NAME_GetSubcategoriesByCategoryId = "usp_GetSubcategoriesByCategoryID";
00150                 public const string SP_NAME_GetMasksByCategoryIdAndSubcategoryId = "usp_GetMasksByCategoryIDandSubcategoryID";
00154                 public const string SP_NAME_GetDistrictsByRegion = "usp_GetDistrictsByRegionID";
00158                 public const string SP_NAME_GetFacilitiesByRegionIdAndDistrictId = "usp_GetFacilitiesByRegionIDandDistrictID";
00162                 public const string SP_NAME_AddDataRoleRestriction = "usp_AddDataRoleRestriction";
00166                 public const string SP_NAME_DeleteDataRoleRestriction = "usp_DeleteDataRoleRestriction";
00170                 public const string SP_NAME_AddFunctionalRoleRestriction = "usp_AddFunctionalRoleRestriction";
00174                 public const string SP_NAME_DeleteFunctionalRoleRestriction = "usp_DeleteFunctionalRoleRestriction";
00178                 public const string SP_NAME_GetFunctionalRoleAttributesByFunctionalRoleID = "usp_GetFunctionalRoleRestrictionsByFunctionalRoleID";
00182                 public const string SP_NAME_GetFunctionalRoleValidationTypes = "usp_GetFunctionalRoleValidationTypes";
00186                 public const string SP_NAME_GetFunctionalRoleTypes = "usp_GetFunctionalRoleTypes";
00190                 public const string SP_NAME_UpdateFunctionalRole = "usp_UpdateFunctionalRole";
00194                 public const string SP_NAME_UpdateDataRole = "usp_UpdateDataRole";
00198                 public const string SP_NAME_GetSupportedLanguages = "usp_GetSupportedLanguages";
00202                 public const string SP_NAME_GetTranslation = "usp_GetTranslation";
00206                 public const string SP_NAME_GetSiteMapByFunctionalRoleID = "usp_GetSiteMapByFunctionalRoleID";
00210         public const string SP_NAME_GetMaskByReference = "usp_GetMaskByReference";        
00214                 public const string SP_NAME_AddSupportedLanguage = "usp_AddSupportedLanguage";
00218                 public const string SP_NAME_UpdateSupportedLanguage = "usp_UpdateSupportedLanguage";
00222                 public const string SP_NAME_DeleteSupportedLanguage = "usp_DeleteSupportedLanguage";
00226                 public const string SP_NAME_GetTranslations = "usp_GetTranslations";
00230         public const string SP_NAME_GetHelp = "usp_GetHelp";
00234                 public const string SP_NAME_UpdateTranslation = "usp_UpdateTranslation";
00238         public const string SP_NAME_UpdateHelp = "usp_UpdateHelp";
00242                 public const string SP_NAME_GetContexts = "usp_GetContexts";
00246                 public const string SP_NAME_GetTableTypes = "usp_GetTableTypes";
00250                 public const string SP_NAME_GetFieldTypes = "usp_GetFieldTypes";
00254                 public const string SP_NAME_GetFieldSizes = "usp_GetFieldSizes";
00258                 public const string SP_NAME_GetNecessityTypes = "usp_GetNecessityTypes";
00262                 public const string SP_NAME_GetTableGroups = "usp_GetTableGroups";
00266                 public const string SP_NAME_UpdateTableGroup = "usp_UpdateTableGroup";
00270                 public const string SP_NAME_GetTableByTableID = "usp_GetTableByTableID";
00274                 public const string SP_NAME_GetTableByTableName = "usp_GetTableByTableName";
00278                 public const string SP_NAME_GetTablesByTableGroupID = "usp_GetTablesByTableGroupID";
00282                 public const string SP_NAME_AddTable = "usp_AddTable";
00286                 public const string SP_NAME_CreateHistoryTable = "usp_CreateHistoryTable";
00290                 public const string SP_NAME_DeleteTable = "usp_DeleteTable";
00294                 public const string SP_NAME_GetFieldsByTableID = "usp_GetFieldsByTableID";
00298                 public const string SP_NAME_GetFieldByID = "usp_GetFieldByID";
00302                 public const string SP_NAME_AddField = "usp_AddField";
00306                 public const string SP_NAME_DeleteField = "usp_DeleteField";
00310                 public const string SP_NAME_UpdateField = "usp_UpdateField";
00314                 public const string SP_NAME_UpdateFieldOrder = "usp_UpdateField_Order";
00318                 public const string SP_NAME_UpdateFieldQueryName = "usp_UpdateField_QueryName";
00322                 public const string SP_NAME_GetDynamicMaskTypes = "usp_GetDynamicMaskTypes";
00326                 public const string SP_NAME_GetDynamicMaskByID = "usp_GetDynamicMaskByID";
00330         public const string SP_NAME_GetDynamicMaskByDynamicMaskName = "usp_GetDynamicMaskByDynamicMaskName";
00334                 public const string SP_NAME_GetDynamicMasksByMaskID = "usp_GetDynamicMasksByMaskID";
00338                 public const string SP_NAME_GetConsistencyChecksByDynamicMaskID = "usp_GetConsistencyChecksByDynamicMaskID";
00342                 public const string SP_NAME_GetDynamicMaskFiltersByDynamicMaskID = "usp_GetDynamicMaskFiltersByDynamicMaskID";
00346                 public const string SP_NAME_GetDynamicMaskFilterParametersByFilterID = "usp_GetDynamicMaskFilterParametersByFilterID";
00350                 public const string SP_NAME_GetModificationTypes = "usp_GetModificationTypes";
00354                 public const string SP_NAME_GetMessageTypes = "usp_GetMessageTypes";
00358                 public const string SP_NAME_GetValidationStatuses = "usp_GetValidationStatuses";
00362                 public const string SP_NAME_GetMessagesByUserToID = "usp_GetMessagesByUserToID";
00366         public const string SP_NAME_GetAllowedFacilityForRestriction = "usp_GetAllowedFacilityForRestriction";
00367 
00368 
00372         public const string SP_NAME_GetAllowedFacilityForRestrictionWithoutFunction = "usp_GetAllowedFacilityForRestrictionWithoutFunction";
00373 
00377                 public const string SP_NAME_GetOpenAccountRequestByUserID = "usp_GetOpenAccountRequestByUserID";
00381                 public const string SP_NAME_AddMessage = "usp_AddMessage";
00385                 public const string SP_NAME_UpdateMessage = "usp_UpdateMessage";
00389                 public const string SP_NAME_UpdateMessageHistoryRowID = "usp_UpdateMessageHistoryRowID";
00393                 public const string SP_NAME_GetFacilityByID = "usp_GetFacilityByID";
00397                 public const string SP_NAME_GetDepartmentByID = "usp_GetDepartmentByID";
00401                 public const string SP_NAME_GetFunctionalRolesByUserTypeID = "usp_GetFunctionalRolesByUserTypeID";
00405                 public const string SP_NAME_GetUserTypesByFunctionalRoleID = "usp_GetUserTypesByFunctionalRoleID";
00409                 public const string SP_NAME_AddUserTypeFunctionalRole = "usp_AddUserTypeFunctionalRole";
00413                 public const string SP_NAME_DeleteUserTypeFunctionalRole = "usp_DeleteUserTypeFunctionalRole";
00417                 public const string SP_NAME_ValidateDeleteUserTypeFunctionalRole = "usp_ValidateDeleteUserTypeFunctionalRole";
00421                 public const string SP_NAME_AddSubcategory = "usp_AddSubcategory";
00425                 public const string SP_NAME_UpdateSubcategory = "usp_UpdateSubcategory";
00429                 public const string SP_NAME_UpdateSubcategory_Order = "usp_UpdateSubcategory_Order";
00433         public const string SP_NAME_UpdateContextVisibleName = "usp_UpdateContextVisibleName";
00437         public const string SP_NAME_DeleteContext = "usp_DeleteContext";
00441                 public const string SP_NAME_DeleteSubcategory = "usp_DeleteSubcategory";
00445                 public const string SP_NAME_GenerateTablesScript = "asp_GetTableAndFieldXmlFromRAISTable";
00449                 public const string SP_NAME_GetProtector = "usp_GetProtector";
00453                 public const string SP_NAME_GetQueryTypes = "usp_GetQueryTypes";
00457                 public const string SP_NAME_GetQueries = "usp_GetQueries";
00461                 public const string SP_NAME_GetQueryByQueryID = "usp_GetQueryByQueryID";
00465                 public const string SP_NAME_GetQueryByQueryName = "usp_GetQueryByQueryName";
00469                 public const string SP_NAME_GetQueryAssignedObjects = "usp_GetQueryAssignedObjects";
00473                 public const string SP_NAME_AddQuery = "usp_AddQuery";
00477                 public const string SP_NAME_UpdateQuery = "usp_UpdateQuery";
00481                 public const string SP_NAME_UpdateQueryCompiled = "usp_UpdateQuery_Compiled";
00485                 public const string SP_NAME_DeleteQuery = "usp_DeleteQuery";
00489                 public const string SP_NAME_GetQueryParameterTypes = "usp_GetQueryParameterTypes";
00493                 public const string SP_NAME_GetQueryParametersByQueryID = "usp_GetQueryParametersByQueryID";
00497                 public const string SP_NAME_AddQueryParameter = "usp_AddQueryParameter";
00501                 public const string SP_NAME_UpdateQueryParameter = "usp_UpdateQueryParameter";
00505                 public const string SP_NAME_UpdateQueryParameterOrder = "usp_UpdateQueryParameter_Order";
00509                 public const string SP_NAME_DeleteQueryParameter = "usp_DeleteQueryParameter";
00513                 public const string SP_NAME_AddMaskAndDynamicMask = "usp_AddMaskAndDynamicMask";
00517                 public const string SP_NAME_UpdateDynamicMask = "usp_UpdateDynamicMask";
00521                 public const string SP_NAME_DeleteDynamicMask = "usp_DeleteDynamicMask";
00525                 public const string SP_NAME_GetRecordTypes = "usp_GetRecordTypes";
00529                 public const string SP_NAME_AddConsistencyCheck = "usp_AddConsistencyCheck";
00533                 public const string SP_NAME_DeleteConsistencyCheck = "usp_DeleteConsistencyCheck";
00537                 public const string SP_NAME_UpdateConsistencyCheck = "usp_UpdateConsistencyCheck";
00541                 public const string SP_NAME_GetUserStatusesHistoryByUserID = "usp_GetUserStatusesHistoryByUserID";
00545                 public const string SP_NAME_GetNonComplianceMajorCategories = "usp_GetNonComplianceMajorCategories";
00549                 public const string SP_NAME_GetNonComplianceCategoriesByMajorCategoryID = "usp_GetNonComplianceCategoriesByMajorCategoryID";
00553                 public const string SP_NAME_GetSearchItems = "usp_GetSearchItems";
00557                 public const string SP_NAME_GetSearchDefinitionsBySearchItem = "usp_GetSearchDefinitionsBySearchItem";
00558                 #endregion
00559         //*********************************************************************
00560         #region Stored Procedures Parameters Names
00561 
00564                 public const string SP_PARAMETER_UserID = "@UserID";
00565 
00566         public const string SP_PARAMETER_SelectedDate = "@SelectedDate";
00570         public const string SP_PARAMETER_MessageDate = "@MessageDate";
00574         public const string SP_PARAMETER_IsLoggOffClick = "@IsLoggOffClick";        
00578                 public const string SP_PARAMETER_UserName = "@UserName";
00582                 public const string SP_PARAMETER_Password = "@Password";
00586                 public const string SP_PARAMETER_UserTypeID = "@UserTypeID";
00590                 public const string SP_PARAMETER_UserStatusID = "@UserStatusID";
00594                 public const string SP_PARAMETER_Email = "@Email";
00598                 public const string SP_PARAMETER_CompleteName = "@CompleteName";
00602                 public const string SP_PARAMETER_AddressLine1 = "@AddressLine1";
00606                 public const string SP_PARAMETER_AddressLine2 = "@AddressLine2";
00610                 public const string SP_PARAMETER_AddressLine3 = "@AddressLine3";
00614                 public const string SP_PARAMETER_City = "@City";
00618                 public const string SP_PARAMETER_PostCode = "@PostCode";
00622                 public const string SP_PARAMETER_FunctionalRoleID = "@FunctionalRoleID";
00626         public const string SP_PARAMETER_Reference = "@Reference";
00630                 public const string SP_PARAMETER_Predefined = "@Predefined";
00634                 public const string SP_PARAMETER_FunctionalRole = "@FunctionalRole";
00638                 public const string SP_PARAMETER_FunctionalRoleName = "@FunctionalRoleName";
00642                 public const string SP_PARAMETER_Facility = "@Facility";
00646                 public const string SP_PARAMETER_FacilityID = "@FacilityID"; //#-#
00650         public const string SP_PARAMETER_PracticeID = "@PracticeID";
00654         //#-#
00655         public const string SP_PARAMETER_ValidFrom = "@ValidFrom";
00659         //#-#
00660         public const string SP_PARAMETER_ValidUntil = "@ValidUntil";
00664                 public const string SP_PARAMETER_DataRoleID = "@DataRoleID";
00668                 public const string SP_PARAMETER_DataRole = "@DataRole";
00672                 public const string SP_PARAMETER_DataRoleName = "@DataRoleName";
00676         public const string SP_PARAMETER_MessageBoxRestrictionID = "@MBRID";
00680                 public const string SP_PARAMETER_RegionID = "@RegionID";
00684                 public const string SP_PARAMETER_DistrictID = "@DistrictID";
00688                 public const string SP_PARAMETER_CategoryID = "@CategoryID";
00692         public const string SP_PARAMETER_WithHidden = "@WithHidden";
00696                 public const string SP_PARAMETER_WithAll = "@WithAll";
00700                 public const string SP_PARAMETER_SubcategoryID = "@SubcategoryID";
00704         public const string SP_PARAMETER_ContextName = "@ContextName";
00708         public const string SP_PARAMETER_ContextVisibleName = "@ContextVisibleName";
00712                 public const string SP_PARAMETER_MaskID = "@MaskID";
00716                 public const string SP_PARAMETER_MaskName = "@MaskName";
00720                 public const string SP_PARAMETER_ViewAccess = "@ViewAccess";
00724                 public const string SP_PARAMETER_AddAccess = "@AddAccess";
00728                 public const string SP_PARAMETER_EditAccess = "@EditAccess";
00732                 public const string SP_PARAMETER_DeleteAccess = "@DeleteAccess";
00736                 public const string SP_PARAMETER_FunctionalRoleValidationTypeID = "@ValidationTypeID";
00740                 public const string SP_PARAMETER_FunctionalRoleTypeID = "@FunctionalRoleTypeID";
00744                 public const string SP_PARAMETER_ContextID = "@ContextID";
00748                 public const string SP_PARAMETER_Context = "@Context";
00752                 public const string SP_PARAMETER_TextToTranslate = "@TextToTranslate";
00756                 public const string SP_PARAMETER_TranslationID = "@TranslationID";
00760                 public const string SP_PARAMETER_TranslatedText = "@TranslatedText";
00764                 public const string SP_PARAMETER_SourceLanguage = "@SourceLanguage";
00768                 public const string SP_PARAMETER_TargetLanguage = "@TargetLanguage";
00769 
00773         public const string SP_PARAMETER_SupportedLanguage = "@SupportedLanguageID";
00774 
00778                 public const string SP_PARAMETER_SortColumn = "@SortColumn";
00782                 public const string SP_PARAMETER_SortDirection = "@SortDirection";
00786                 public const string SP_PARAMETER_SupportedLanguageID = "@SupportedLanguageID";
00790                 public const string SP_PARAMETER_SupportedLanguageName = "@SupportedLanguageName";
00794                 public const string SP_PARAMETER_SupportedLanguageEnglishName = "@SupportedLanguageEnglishName";
00798                 public const string SP_PARAMETER_RightToLeft = "@RightToLeft";
00802                 public const string SP_PARAMETER_Untranslated = "@Untranslated";
00806                 public const string SP_PARAMETER_TableGroupID = "@TableGroupID";
00810                 public const string SP_PARAMETER_Accepted = "@Accepted";
00814                 public const string SP_PARAMETER_TableID = "@TableID";
00818                 public const string SP_PARAMETER_TableName = "@TableName";
00822                 public const string SP_PARAMETER_TableTypeID = "@TableTypeID";
00826                 public const string SP_PARAMETER_Hidden = "@Hidden";
00830                 public const string SP_PARAMETER_ShowProtectors = "@ShowProtectors";
00834                 public const string SP_PARAMETER_ShowEvaluators = "@ShowEvaluators";
00838                 public const string SP_PARAMETER_FieldID = "@FieldID";
00842                 public const string SP_PARAMETER_FieldName = "@FieldName";
00846                 public const string SP_PARAMETER_LocalLanguageFieldName = "@LocalLanguageFieldName";
00850                 public const string SP_PARAMETER_FieldPurpose = "@FieldPurpose";
00854                 public const string SP_PARAMETER_LocalLanguageFieldPurpose = "@LocalLanguageFieldPurpose";
00858                 public const string SP_PARAMETER_FieldTypeID = "@FieldTypeID";
00862                 public const string SP_PARAMETER_FieldSizeID = "@FieldSizeID";
00866                 public const string SP_PARAMETER_NecessityTypeID = "@NecessityTypeID";
00870                 public const string SP_PARAMETER_Order = "@Order";
00874                 public const string SP_PARAMETER_IsNameField = "@IsNameField";
00878                 public const string SP_PARAMETER_SystemField = "@SystemField";
00882                 public const string SP_PARAMETER_VisibleOnForms = "@VisibleOnForms";
00886                 public const string SP_PARAMETER_UniqueValue = "@UniqueValue";
00890                 public const string SP_PARAMETER_NeedsTranslation = "@NeedsTranslation";
00894                 public const string SP_PARAMETER_Multiline = "@Multiline";
00898                 public const string SP_PARAMETER_HighField = "@HighField";
00902                 public const string SP_PARAMETER_ReadOnly = "@ReadOnly";
00906                 public const string SP_PARAMETER_RelatedTableID = "@RelatedTableID";
00910                 public const string SP_PARAMETER_CustomTable = "@CustomTable";
00914                 public const string SP_PARAMETER_NeedsValidation = "@NeedsValidation";
00918                 public const string SP_PARAMETER_DynamicMaskID = "@DynamicMaskID";
00922         public const string SP_PARAMETER_DynamicMaskName = "@DynamicMaskName";
00926                 public const string SP_PARAMETER_DynamicMaskTypeID = "@DynamicMaskTypeID";
00930                 public const string SP_PARAMETER_AddForeignKeyField = "@AddForeignKeyField";
00934                 public const string SP_PARAMETER_CreateDynamicMask = "@CreateDynamicMask";
00938                 public const string SP_PARAMETER_DynamicMaskFilterID = "@DynamicMaskFilterID";
00942                 public const string SP_PARAMETER_MessageID = "@MessageID";
00946                 public const string SP_PARAMETER_UserFromID = "@UserFromID";
00950                 public const string SP_PARAMETER_UserToID = "@UserToID";
00954                 public const string SP_PARAMETER_RowID = "@RowID";
00958                 public const string SP_PARAMETER_HistoryRowID = "@HistoryRowID";
00962                 public const string SP_PARAMETER_Comment = "@Comment";
00966                 public const string SP_PARAMETER_ModificationTypeID = "@ModificationTypeID";
00970                 public const string SP_PARAMETER_MessageTypeID = "@MessageTypeID";
00974                 public const string SP_PARAMETER_ValidationStatusID = "@ValidationStatusID";
00978                 public const string SP_PARAMETER_DepartmentID = "@DepartmentID";
00982                 public const string SP_PARAMETER_Success = "@Success";
00986                 public const string SP_PARAMETER_WithRelatedFields = "@WithRelatedFields";
00990                 public const string SP_PARAMETER_SubcategoryName = "@SubcategoryName";
00994                 public const string SP_PARAMETER_CustomSubcategory = "@CustomSubcategory";
00998                 public const string SP_PARAMETER_ImageIndex = "@ImageIndex";
01002                 public const string SP_PARAMETER_QueryID = "@QueryID";
01006                 public const string SP_PARAMETER_QueryName = "@QueryName";
01010                 public const string SP_PARAMETER_QueryText = "@QueryText";
01014                 public const string SP_PARAMETER_QueryTypeID = "@QueryTypeID";
01018                 public const string SP_PARAMETER_QueryParameterID = "@QueryParameterID";
01022                 public const string SP_PARAMETER_QueryParameterName = "@QueryParameterName";
01026                 public const string SP_PARAMETER_QueryParameterTypeID = "@QueryParameterTypeID";
01030                 public const string SP_PARAMETER_RelatedQueryID = "@relatedQueryID";
01034                 public const string SP_PARAMETER_QueryParametersXML = "@QueryParametersXML";
01038                 public const string SP_PARAMETER_DynamicMaskFiltersXML = "@DynamicMaskFiltersXML";
01042                 public const string SP_PARAMETER_VisibleName = "@VisibleName";
01046                 public const string SP_PARAMETER_Grouping = "@Grouping";
01050                 public const string SP_PARAMETER_Widths = "@Widths";
01054                 public const string SP_PARAMETER_Footer = "@Footer";
01058                 public const string SP_PARAMETER_ConsistencyCheckID = "@ConsistencyCheckID";
01062                 public const string SP_PARAMETER_Message = "@Message";
01066                 public const string SP_PARAMETER_RecordTypeID = "@RecordTypeID";
01070                 public const string SP_PARAMETER_NonComplianceMajorCategoryID = "@NonComplianceMajorCategoryID";
01074                 public const string SP_PARAMETER_SearchItem = "@SearchItem";
01078                 public const string SP_PARAMETER_SearchText = "@SearchText";
01082         public const string SP_PARAMETER_HelpText = "@HelpText";
01086                 public const string SP_PARAMETER_Compiled = "@Compiled";
01087         public const string QUERY_TEXT_HAS_ROWS = "select count(*) from [{0}]";
01088                 #endregion
01089 
01092         public const string DATA_BASE_ERROR_MASSAGE = "<br/>(This error has been returned from the SQL Server).";
01093 
01094 
01095 
01096 
01100         public const string SP_NAME_NewMessageboxRestriction = "usp_NewMessageboxRestriction";
01101 
01105         public const string SP_NAME_EditMessageboxRestriction = "usp_UpdateMessageBoxRestriction";
01106 
01110         public const string SP_NAME_DeleteMessageboxRestriction = "usp_DeleteMessageBoxRestriction";
01111 
01112         public const string SP_NAME_GetMessageBoxDataRoleByUserAndDate = "usp_GetMessageBoxDataRoleByUserAndDate";
01113 
01117         public const string SP_NAME_GetRestrictionHistoryForUser = "usp_GetRestrictionHistoryForUser";
01118 
01122         public const string SP_NAME_GetUserFreeToTakeOver = "usp_GetUserFreeToTakeOver";
01123 
01127         public const string SP_NAME_GetUserTakenOverByUser = "usp_GetUserTakenOverByUser";
01128  //#-#
01132         public const string SP_NAME_CreateUserAssignment = "usp_CreateUserAssignment";
01133  //#-#
01137         public const string SP_NAME_DeleteUserAssignment = "usp_DeleteUserAssignment";
01138  //#-#
01142         public const string SP_NAME_UpdateUserAssignment = "usp_UpdateUserAssignment";
01143 
01147         public const string SP_NAME_ClearTakeOverForUser = "usp_ClearTakeOverForUser";
01151         public const string SP_NAME_GetMessageBoxTakenOverDataRolesByUserID = "usp_GetMessageBoxTakenOverDataRolesByUserID"; // #+#
01155         public const string SP_NAME_GetMessageBoxDataRoleByUser = "usp_GetMessageBoxDataRoleByUser";
01156  // #-#
01160         public const string SP_NAME_GetActiveMessageBoxRestrictionsForUser = "usp_GetActiveMessageBoxRestrictionsForUser";
01161 
01165         // #-#
01166         public const string SP_NAME_GetAllActiveMessageBoxRestrictionsForUser = "usp_GetAllActiveMessageBoxRestrictionsForUser";
01167 
01168         /*
01169         \brief Get all Facilities that are connected with given practice.
01170          */
01171         public const string SP_NAME_GetFacilitiesByPractice = "usp_GetFacilitiesByPractice";
01172 
01176         public const string SP_NAME_GetUserAssignmentsForUser = "usp_GetUserAssignmentsForUser";
01177 
01178         //#-#
01182         public const string SP_NAME_GetFacilitiesByPracticeID = "usp_GetFacilitiesByPracticeID";
01183 
01184         /*
01185         \brief Get all UserAssignments of given User
01186          */
01187         public const string SP_NAME_GetUserAssignmentHistoryForUser = "usp_GetUserAssignmentHistoryForUser";
01188 
01192         public const string SP_NAME_GetRegionForFacility = "usp_GetRegionForFacility";
01193 
01194         }
01195 }